Invoicing Setup (IVC40100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IVC40100

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Setup
Physical Name: IVC40100
Technical Name: IVC_SETP

Group Display Name: Invoice Setup
Group Technical Name: Invoice Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SETUPKEY SearchSetup KeyIntegerINT0
2DPYITMCS SearchDisplay Item Unit CostBooleanCB_Display_Item_Unit_Cost0
3ACDSTRBN SearchAccount DistributionsBooleanCB_Account_Distributions0
4TRKVDTRX SearchTrack Voided Trx In HistoryBooleanCB_Track_Voided_Trx_In_History0
5TRXDTL SearchTransaction DetailBooleanCB_Transaction_Detail0
6LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Invoicing Setup'].LOCNCODE AS 'Invoicing Setup-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Invoicing Setup'].LOCNCODE = ['Site Setup'].LOCNCODE
7CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Invoicing Setup'].CHEKBKID AS 'Invoicing Setup-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Invoicing Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
8INVCFRMT SearchInvoice FormatIntegerDDL_Invoice_Formats0
9RETNFRMT SearchReturn FormatIntegerDDL_Invoice_Formats0
10PKSLPFMT SearchPacking Slip FormatIntegerDDL_Invoice_Formats0
11DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
12DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
13USEADVTX SearchUse Advanced TaxesIntegerGB0
14NONIVSCH SearchNon IV Item Schedule IDStringSTR15_Tax_Schedule_ID15
15FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Setup'].FRTSCHID AS 'Invoicing Setup-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Setup'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
16MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Setup'].MSCSCHID AS 'Invoicing Setup-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Setup'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
17TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Invoicing Setup'].TAXSCHID AS 'Invoicing Setup-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Invoicing Setup'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
18NONIVTXB SearchNon IV TaxableIntegerDDL_Tax_Options0
19FRGTTXBL SearchFreight TaxableIntegerDDL_Tax_Options0
20MISCTXBL SearchMisc TaxableIntegerDDL_Tax_Options0
21USRDFPR1 SearchUser Defined Prompt 1StringSTR1515
22USRDRPR2 SearchUser Defined Prompt 2StringSTR1515
23USEACFRM SearchUse Posting Accounts FromIntegerGB0
24RTNUSIVC SearchReturn Use InvoiceBooleanCB_Return_Use_Invoice0
25PKSLPIVC SearchPacking Slip Use InvoiceBooleanCB_Packing_Slip_Use_Invoice0
26COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Invoicing Setup'].COMMNTID AS 'Invoicing Setup-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       IVC40100 AS ['Invoicing Setup']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Invoicing Setup'].COMMNTID = ['Comment Master'].COMMNTID
27IVCALLOW SearchIVC AllowCBBoolean0
28IVCALLOW_1 SearchIVC Allow[1]BooleanCB0
29IVCALLOW_2 SearchIVC Allow[2]BooleanCB0
30IVCALLOW_3 SearchIVC Allow[3]BooleanCB0
31IVCALLOW_4 SearchIVC Allow[4]BooleanCB0
32IVCALLOW_5 SearchIVC Allow[5]BooleanCB0
33IVCALLOW_6 SearchIVC Allow[6]BooleanCB0
34IVCALLOW_7 SearchIVC Allow[7]BooleanCB0
35IVCALLOW_8 SearchIVC Allow[8]BooleanCB0
36IVCALLOW_9 SearchIVC Allow[9]BooleanCB0
37IVCALLOW_10 SearchIVC Allow[10]BooleanCB0
38IVCALLOW_11 SearchIVC Allow[11]BooleanCB0
39IVCPSSWD_1 SearchIVC Password[1]StringPassword10
40IVCPSSWD_2 SearchIVC Password[2]StringPassword10
41IVCPSSWD SearchIVC PasswordPasswordString10
42IVCPSSWD_3 SearchIVC Password[3]StringPassword10
43IVCPSSWD_4 SearchIVC Password[4]StringPassword10
44IVCPSSWD_5 SearchIVC Password[5]StringPassword10
45IVCPSSWD_6 SearchIVC Password[6]StringPassword10
46IVCPSSWD_7 SearchIVC Password[7]StringPassword10
47IVCPSSWD_8 SearchIVC Password[8]StringPassword10
48IVCPSSWD_9 SearchIVC Password[9]StringPassword10
49IVCPSSWD_10 SearchIVC Password[10]StringPassword10
50IVCPSSWD_11 SearchIVC Password[11]StringPassword10
51IVCSEQNC_1 SearchIVC Sequence[1]IntegerINT44
52IVCSEQNC_2 SearchIVC Sequence[2]IntegerINT44
53IVCSEQNC SearchIVC SequenceINT4Integer4
54IVCSEQNC_3 SearchIVC Sequence[3]IntegerINT44
55IVCSEQNC_4 SearchIVC Sequence[4]IntegerINT44
56IVCSEQNC_5 SearchIVC Sequence[5]IntegerINT44
57IVCSEQNC_6 SearchIVC Sequence[6]IntegerINT44
58IVCSEQNC_7 SearchIVC Sequence[7]IntegerINT44
59IVCSEQNC_8 SearchIVC Sequence[8]IntegerINT44
60IVCSEQNC_9 SearchIVC Sequence[9]IntegerINT44
61IVCSEQNC_10 SearchIVC Sequence[10]IntegerINT44
62IVCSEQNC_11 SearchIVC Sequence[11]IntegerINT44
63IVCDSTCK SearchIVC Dist CheckLong IntegerML_IVC_Dist_Check0
64NUMOFTRX SearchNumber Of TRXLong IntegerLI6_U06

Leave a Reply

Your email address will not be published. Required fields are marked *